Changing an item from the dynamically generated list

When dynamically generated list has been selected as a parameter, a parameter resolution engine generates the following screen:

 

 

You can clearly see the list of available values in this list. The entire list has been generated in the runtime, using the information supplied during the definition phase of this parameter.

Remember, we wanted to get all available measure captions (for display values) and corresponding measure unique names (for substitution values). Therefore, Cube PLAYER used the supplied connection string to establish the actual OLAP connection to the selected server and database (not necessarily the same one as we are currently working on) and, once a connection has been successfully opened, it executed the supplied MDX SELECT command.

The end-user has a simple choice of selecting one of the existing items. In this example, we shall select the Store Sales Net (last one) and click on the Accept button.

When a new selection has been made, the new substitution value is immediately indicated in the Set MDX parameters dialog: